apke to sabhi vedio like karna chahiye ... sabhi vedio helpfull he .. hamesh students ko bolta hu .. shahab Islam ko Excel me ... 1st he..Thanks Dear..
Mr sahab islam ji you very good instructor , i am from india AP age 65 retired employee from kuwait , ji i am learning excel formulas and small stalling code from you ,every i am searching in youtube next i want to learn from you Access. Thank you and God bless , allah hafis
Very well Sir. Bahut accha samjhaya Ek gujarish hai aapse- office hardware aur usko employees ko distribute karne ke bad kitna hardware bacha hai. Aur kon sa hardware kis employee ke pas hai. Isko excel m kaise manage karenge. Is par ek video bana dijiye, to badi maharvani hogi aapki.
Assalamo alaikum Sir sheet jb ban jate hai to dubara jb open karty ha in jb dosre sheet pr clik kartay hain to agli sheet pr click ho jate hai pls reply
Sir I need your I have have make one make like your video sheet but I need one I make change is sheet 2 the changes apply on sheet 2 and master sheet remain as like before and how I can do this ?
The process goes on smoothly till creating corresponding sheets but while updating the records in main sheet the corresponding sheet does not get updated please guide
Assalamu alaikum Sir I am Abdur Raqeeb from Saudi Arabia. Actually mujhe ye janna hai ke dusre sheet se full data transfer krna hai srf ek code k thru jaise ek fleet code dalu to uska full details dusre sheet me aa jana chahiye, please mujhe thoda btaye.
Sir aap ka video tho mujhe bahut pasand aaya. So, A Grate Thanks for this information. But, sir mera aap se ek Question hai.... Sir aap ne tho ek chota data me bata diyeo ho . But sir eahi kaam Mai agar ek big data me karna chaun tho Maan lijiyea Ten Thousand ROW ka data hai Advance Filter ka copy to another location me Jane ke baad jo Table Range Dena hota hai Kiya har bar ussko vaise hi mouse se select & drag and drop kar ke Dena ho ga, Yaa phir uss ke liye koi shortcut hai yaa koi dusra tarqib hai. Please sir reply me
Sir sheet safe krny ky bad jb dobara open krty hain aur phir data wright krty hain to vo data automatic shift ni hota dosri shift main. Please tariqa bata dain
Sir ap please ak formula bataiye . Ki excel ki first sheet mai agar date wise entry kare or us entry ke piche yadi koi code ya no. Dal de yadi to us related next sheet column mai wo entry kya chali jayegi
Could you help me regarding this doubt I have 2 Excel files First file having 10 customers data (unique ID no., name Age, salary). Second file has 15 customers data (unique ID no., name Age, salary). But both files have 7 common customers. I want that, if my changes 1st file data (salary data) of some customer .The changes should be automatically updated in 2nd file for that customer. Example: If I change the salary of a person (in 1st file), then Excel should identify the unique ID no. (In 1st file) And after that Excel will automatically search this unique ID no. In 2nd file and after searching, Excel will update salary for that unique ID no.
Assalm O Alekum Brother. I need to ask if you can help me create an excel database for red meat slaughtering and distributing to multiple customers while getting multiple items from multiple vendors. Thanks in anticipation brother.
Asalam Alaikum sir, Sir Main Same Video step follow kiye sheet sub kuch banaya but VBA me aik Issue a Raha *Sub Or Function Not Defined Is ka Solution batao plz
Hi sir , suppose we have performed the filter function once and then we change the course of Ghulam to CIT , then the changed value would be reflected in autocad sheet automatically??
hello sir maine excel sheet create kiya hain with use hyperlink but mere pass 150 member hain unka rent monthly hain mujhe per member rent chahiye per month kitna received hua kitna pending hain monthly wise agar koi video hain to muhje share kare ja mujhe koi tips de ki kaise karu please help thankss
Islam sb salam. Pls guide karna. Mere paas ek sheet pe 120 employees ki daily attendance aaraha hai. In may say koi Peshawar may hai to koi Karachi may hai. May chahta hon ke jon hi may naam ke samne entry karon, dosre sheet pe "P" (Present), "R" (Resigned) ya "T" (Terminated) aajaen. Kia ye mumkin hai?
Ass Salam Walekum Sir Sir aap ne bahut ache se samja ya , I leared very well, Sir ek puch na tha mea same format mea Invoice sheet banaya , woh sheet per Outstanding balance rakha, baad me agar koi customer outstanding paid ker hai ta toh automatically outstanding mea se woh entry delete ho na chahiye , woh kaise hogaya sir , please muje batao
Nice topic but when I use safe option di log box appears and asks file can't save micro enable but u have said u have already saved file pls guide me onwards I am waiting for ur guidance
How to filter record and store filters record in seaprate worksheet. For example I have file of my district I want to filter record of each TEHSIL and saved in separate worksheet .pls share trick or code if you know
Hi Very nice and informative video, Could make a video where automatically I'n my worksheet the payment add, minus, multiply or divided when I received from customer or for my own record. Thanks Rani
you prolly dont give a shit but if you guys are bored like me during the covid times then you can watch pretty much all the latest movies and series on InstaFlixxer. Have been streaming with my girlfriend for the last days =)
hello sir during activate the work book command said " be careful! parts of your document may include personal information that can't be removed by the document inspector
Sir Can I transfer particular type data from 2 or 3 sheets at a time to other sheets? In this video I learned how to transfer from one sheet to another. Plz reply 🙏
Bahut badiya samjhya aap ne. ❤
apke to sabhi vedio like karna chahiye ... sabhi vedio helpfull he .. hamesh students ko bolta hu .. shahab Islam ko Excel me ... 1st he..Thanks Dear..
سر اگر ہم نے AUTOCAD ورک شیٹ میں مارننگ اور ایوننگ کی الگ الگ ٹیبل میں کرنا چاہیں تو 2 MACROS کیسے رن کریں گے AUTOCAD والی شیٹ میں؟
Masha ALLAH Shahab Sahab Great Jazak ALLAH ALLAH Bless You
Lot of video view on advance, these is what I want automatically transfer Dat thank you sir
Assalam u alaikum
Sir (view code) Mai jaa k( call cit )qn likh rahy Hain iski kia logic hai?
Kuch or qn nh likh sakty?
Amazing teaching style that can easily understand i will make sure to share as i can.
sir thanks
sir agr hum data paste krty hen tu kya auto sb sheet meh catagorywise ajayega?
Mr sahab islam ji you very good instructor , i am from india AP age 65 retired employee from kuwait , ji i am learning excel formulas and small stalling code from you ,every i am searching in youtube next i want to learn from you Access. Thank you and God bless , allah hafis
Very well Sir. Bahut accha samjhaya
Ek gujarish hai aapse- office hardware aur usko employees ko distribute karne ke bad kitna hardware bacha hai. Aur kon sa hardware kis employee ke pas hai. Isko excel m kaise manage karenge. Is par ek video bana dijiye, to badi maharvani hogi aapki.
Assalamo alaikum
Sir sheet jb ban jate hai to dubara jb open karty ha in jb dosre sheet pr clik kartay hain to agli sheet pr click ho jate hai pls reply
If we delete any data from master sheet, will it automatically get deleted from these sheets?
Sir I need your I have have make one make like your video sheet but I need one I make change is sheet 2 the changes apply on sheet 2 and master sheet remain as like before and how I can do this ?
Sir ap boht Acha sikhate hain
The process goes on smoothly till creating corresponding sheets but while updating the records in main sheet the corresponding sheet does not get updated please guide
You are very encouraging and promoting 😊😊😊
السلام علیکم اگر ہم ایک ہی رو پر جنوری فروری مارچ ایک اسٹوڈنٹ کی فیس سیٹ کرانا چاہتے ہیں تو اس کی ڈیٹ اینٹری کیسے ہوئی اس کا فارمولا کیا ہوگا شکریہ
Hi sir , will this work on Google sheet also??
Sir...last me view k bad jo save karna tha..wo toh auto save ho gaya..no dialoge box came...avi main sheet ko save as macro enable karu kya ??
Assalamu alaikum
Sir I am Abdur Raqeeb from Saudi Arabia. Actually mujhe ye janna hai ke dusre sheet se full data transfer krna hai srf ek code k thru jaise ek fleet code dalu to uska full details dusre sheet me aa jana chahiye, please mujhe thoda btaye.
ruclips.net/channel/UCcOsbNCxgUZMPoHEI1w-1RAsearch?query=match%20and%20vlookup
Sir aap ka video tho mujhe bahut pasand aaya.
So, A Grate Thanks for this information.
But, sir mera aap se ek Question hai....
Sir aap ne tho ek chota data me bata diyeo ho . But sir eahi kaam Mai agar ek big data me karna chaun tho Maan lijiyea Ten Thousand ROW ka data hai Advance Filter ka copy to another location me Jane ke baad jo Table Range Dena hota hai Kiya har bar ussko vaise hi mouse se select & drag and drop kar ke Dena ho ga, Yaa phir uss ke liye koi shortcut hai yaa koi dusra tarqib hai.
Please sir reply me
Sir when i am using call function and then entering the data then it is not visible in another sheet what should i do
Dear shahab Islam, outstanding Video & massive Advice, amazing, cute,wonderful great, super, kindly more Advance in excel regarding Conditional formatting. Warm regards, Hamid.
Good efforts from Saudia arabia
Nargis Tech
Thanks and welcome
sir outstanding awala awala
Sir sheet safe krny ky bad jb dobara open krty hain aur phir data wright krty hain to vo data automatic shift ni hota dosri shift main. Please tariqa bata dain
SIR AKHRI ENTRY DATA CONTINUE M ERROR AJATA HAI
Restaurant monthly and weekly food inventory video please upload kijia
Sir yadi double course lena ho ek sheet me tab kaise hoga
Sir ap please ak formula bataiye .
Ki excel ki first sheet mai agar date wise entry kare or us entry ke piche yadi koi code ya no. Dal de yadi to us related next sheet column mai wo entry kya chali jayegi
I want my excel data to my others Xcel forms data sheets ? Need you help plz
Sir agar hm close karke fir kam krte hai to automatic data transfer nhi hota
Thank you for your teaching on automatic data transferring trick
You are most welcome
Ye formula kisi or file sheet pe apply ho skta h
Can we do the same in Google sheet?
Can I transfer two cources to one sheet. Example was for one cource
Could you help me regarding this doubt
I have 2 Excel files
First file having 10 customers data (unique ID no., name Age, salary).
Second file has 15 customers data (unique ID no., name Age, salary).
But both files have 7 common customers.
I want that, if my changes 1st file data (salary data) of some customer .The changes should be automatically updated in 2nd file for that customer.
Example:
If I change the salary of a person (in 1st file), then Excel should identify the unique ID no. (In 1st file) And after that Excel will automatically search this unique ID no. In 2nd file and after searching, Excel will update salary for that unique ID no.
Bhot hi Ala ❤❤❤❤
Very important and useful. Thanks🙏🙏🙏❤
Most welcome 😊
Assalm O Alekum Brother. I need to ask if you can help me create an excel database for red meat slaughtering and distributing to multiple customers while getting multiple items from multiple vendors. Thanks in anticipation brother.
Asalam Alaikum sir,
Sir Main Same Video step follow kiye sheet sub kuch banaya but VBA me aik Issue a Raha
*Sub Or Function Not Defined
Is ka Solution batao plz
Amazing techniques .....great sir jee....Shabir - Dubai
Many many thanks
Sir ek sheet me type karu or us naam se dusra sheet auto create ho kar usme data entry ho sakta hai kya
yes
Hi sir , suppose we have performed the filter function once and then we change the course of Ghulam to CIT , then the changed value would be reflected in autocad sheet automatically??
Excellent boss. I am searching for it. Thanks
Most welcome
Excellent!
Auto Update - Good Technique
Thanks!
hello sir maine excel sheet create kiya hain with use hyperlink but mere pass 150 member hain unka rent monthly hain mujhe per member rent chahiye per month kitna received hua kitna pending hain monthly wise agar koi video hain to muhje share kare ja mujhe koi tips de ki kaise karu please help thankss
ruclips.net/video/ggp8WABEKYo/видео.html
Good 👍👍❤❤❤❤
Islam sb salam. Pls guide karna. Mere paas ek sheet pe 120 employees ki daily attendance aaraha hai. In may say koi Peshawar may hai to koi Karachi may hai. May chahta hon ke jon hi may naam ke samne entry karon, dosre sheet pe "P" (Present), "R" (Resigned) ya "T" (Terminated) aajaen. Kia ye mumkin hai?
g he.
Ass Salam Walekum Sir
Sir aap ne bahut ache se samja ya , I leared very well,
Sir ek puch na tha mea same format mea Invoice sheet banaya , woh sheet per Outstanding balance rakha, baad me agar koi customer outstanding paid ker hai ta toh automatically outstanding mea se woh entry delete ho na chahiye , woh kaise hogaya sir , please muje batao
Agar multiple column se select karnna hai to?
Suppose autocad 4 colum me hai
Agar ek hi sheet me multiple macro apply karne ho to wo kaise karenge
Dear Sir, i have one Problem in file While using Micro please help me to fix it....!
Good way
I did all steps the same but new entries not copied to the next sheet, it messege me (compile error)
Sir,
Assalamualaikum,
Agr hm isme new item add krna chahe to kaise krenge. Pl.tell me & Show in video.
Sir thanks that's good
Welcome
Thank u sir
Sir can I transfer data using two specification like morning Autocad and evening autocad. if yes, then how
Nice topic but when I use safe option di log box appears and asks file can't save micro enable but u have said u have already saved file pls guide me onwards I am waiting for ur guidance
اسلام وعلیکم. ایک گروپ.جس 70 انچارج اور رکن 2200 سو سے زیادہ ہیں. اس کی ترتیب کے مطلق معلومات شیر کریں. شکریہ
Marvelllous JazakAllah Aameen
Nice and very helpful
Thanks a lot
Ek function aesa bhi hota hai k sirf ek cell mai code ya nam likhte hain to new sheet me uski pori information ajati hai previous data sheet se
g ye topic upload he channel p
Sir data to Dori sheet MA ja raha hai agar account chalana Ho to kase har party ka har sheets MA + end - auto Ho plz
Help 😊❤
How to filter record and store filters record in seaprate worksheet. For example I have file of my district I want to filter record of each TEHSIL and saved in separate worksheet .pls share trick or code if you know
Great work. Sir i want to do some work in excel VBA for development project. I need help ?
Is this also available in google sheets???
No
kiya ish tarah ap party ka ledger banna saghtay hai????
I like it..Thnks!
Salam o Alykum sir
Hi Very nice and informative video,
Could make a video where automatically I'n my worksheet the payment add, minus, multiply or divided when I received from customer or for my own record.
Thanks
Rani
GOOD JOB
Good
DEAR SIR I HAVE TRIED IT BUT WHEN I DONE THEN START ENTRIY BUT IT SHOWS ME ERRIR IN CODING SYSTEM
facing difficulty in updating new data, please help
Countering error 9. Can't make more the 2 sheet. Please help
Assalamoalaykum marvellous performance MashaAllah greatest
Nargis Tech
you prolly dont give a shit but if you guys are bored like me during the covid times then you can watch pretty much all the latest movies and series on InstaFlixxer. Have been streaming with my girlfriend for the last days =)
@Arlo Francis Definitely, have been using instaflixxer for months myself :)
I tried this but 2nd part I am having a problem (VIEW Code) its not working, someone can help me in this matter pls.
If criteria is Class Grade 4, then?
Nice
Badhya explain Kiya hai and is me sheets k tab or button Kaise create ki tab press karte hai to particular subject ka pura record show ho jai
LINK BOOKMARK OPTION SE
@@shahabislam4912 matlub bookmark options se sheets ko link Karna hai
Very helpful and useful video sir
Keep watching
Sir is macro ka use kaha hua? Please clear kare
Same cash book ledger methoed . Right sir
Yes, correct
MASHAALLAH
Dear shahab Islam, excellent & brilliant teaching. Regards, Hamid
Khali date select kare toh saare sheet ka data kaise ana 12 months ki alag alag sheet hai
Master file mai Change hone par auto update kese hoga...
sir data to aajata ha lekin last jab entery karta hon doosri sheet pe nhn ja rahi ha please guid me sir.
Can we copy or move data from one excel sheet to other using paste special
hello sir
during activate the work book command said " be careful! parts of your document may include personal information that can't be removed by the document inspector
Sir this excel sheet witch version
2019
How to make new macro records if it is number
Hey how can I do the same in Google sheet ??
I will check and let you know
Call AutoCAD kun likha?
Iskey jga kuch aur kun nhe likh skty??
Ye kis waja sy likhty?
Thanks
Sir Can I transfer particular type data from 2 or 3 sheets at a time to other sheets?
In this video I learned how to transfer from one sheet to another. Plz reply 🙏
DATA TOH TRANSFER HO RHA HAI CODING MAI CALL NAME KE BAAD ERROR ARHA HAI ADVANCE FILTER METHOD OF RANGE CLASS FAILED KINDLY SUGGEST WHAT TO DO
how to fill same data on same sheet in different column